﻿using System;
using System.Collections.Generic;
using System.Linq;
using HotelManageSystem.Domain;
using System.Data.Entity;
using HotelManageSystem.Domain.Entities;

namespace HotelManageSystem.DAL.IntializerDataBase
{
    public class DataBaseIntializer : DropCreateDatabaseIfModelChanges<HotelManageSystemDbContext>
    {
        protected override void Seed(HotelManageSystemDbContext context)
        {
            //货品类别
            var productCategories = new List<ProductCategory>
                                        {
                                            new ProductCategory {ID = 1, Name = "矿泉水", Remark = "矿泉水中包含很多种类的水，如……"},
                                            new ProductCategory {ID = 2, Name = "面包", Remark = "面包中包含很多种类的面包，如……"},
                                            new ProductCategory {ID = 3, Name = "泡面", Remark = "泡面中包含很多种类的泡面，如……"},
                                            new ProductCategory {ID = 4, Name = "内衣", Remark = "内衣中包含很多种类的内衣，如……"},
                                            new ProductCategory {ID = 5, Name = "内裤", Remark = "内裤中包含很多种类的内裤，如……"},
                                            new ProductCategory {ID = 6, Name = "袜子", Remark = "袜子中包含很多种类的袜子，如……"},
                                            new ProductCategory {ID = 7, Name = "洗头膏", Remark = "洗头膏中包含很多种类的洗头膏，如……"},

                                            //
                                        };

            //证件类型
            var certificateTypes = new List<CertificateType>
                                       {
                                           new CertificateType {ID = 1, Name = "身份证"},
                                           new CertificateType {ID = 2, Name = "护照"},
                                           new CertificateType {ID = 3, Name = "军官证"}

                                       };
            //用户类别
            var clientTypes = new List<ClientType>
                                  {
                                      new ClientType {ID = 1, Name = "普通会员",Discount = "0.9",Remark = "很好"},
                                      new ClientType {ID = 2, Name = "中级会员",Discount = "0.8",Remark = "很好"},
                                      new ClientType {ID = 3, Name = "高级会员",Discount = "0.7",Remark = "很好"},
                                      new ClientType {ID = 4, Name = "一般用户",Discount = "1",Remark = "很好"}
                                  };

            //房间类型
            var roomType = new List<RoomType>
                               {
                                   new RoomType {ID = 1, Name = "标准单人间",Price = 138,Remark = "很好"},
                                   new RoomType {ID = 2, Name = "标准双人间",Price = 198,Remark = "很好"},
                                   new RoomType {ID = 3, Name = "普通单人间",Price = 88,Remark = "很好"},
                                   new RoomType {ID = 4, Name = "普通双人间",Price = 128,Remark = "很好"},
                                   new RoomType {ID = 5, Name = "豪华单人间",Price = 258,Remark = "很好"},
                                   new RoomType {ID = 6, Name = "豪华双人间",Price = 488,Remark = "很好"},
                                   new RoomType {ID = 7, Name = "豪华多人间",Price = 600,Remark = "很好"}
                           
                               };
            //楼层
            var floors = new List<Floor>
                             {
                                 new Floor {ID = 1, Name = "一楼",Remark = "很好"},
                                 new Floor {ID = 2, Name = "二楼",Remark = "很好"},
                                 new Floor {ID = 3, Name = "三楼",Remark = "很好"},
                                 new Floor {ID = 4, Name = "四楼",Remark = "很好"},
                                 new Floor {ID = 5, Name = "五楼",Remark = "很好"},
                                 new Floor {ID = 6, Name = "六楼",Remark = "很好"},
                                 new Floor {ID = 7, Name = "七楼",Remark = "很好"},
                                 new Floor {ID = 8, Name = "八楼",Remark = "很好"}

                             };
            //房间状态
            var roomStates = new List<RoomState>
                                 {
                                     new RoomState {ID = 1, Name = "空闲",Remark = "很好"},
                                     new RoomState {ID = 2, Name = "入住",Remark = "很好"},
                                     new RoomState {ID = 3, Name = "维修",Remark = "很好"},
                                     new RoomState {ID = 4, Name = "打扫",Remark = "很好"},
                                     new RoomState {ID = 5, Name = "预定",Remark = "很好"}

                                 };
            //房间信息
            var room = new List<Room>
                           {
                               new Room
                                   {
                                       ID = "101",
                                       Name = "101",
                                       BedNum = 1,
                                       Telphone = "12345",
                                       RoomType = roomType.FirstOrDefault(x => x.ID == 2),
                                       RoomState = roomStates.FirstOrDefault(x => x.ID == 1),
                                       Floor = floors.FirstOrDefault(x => x.ID == 1)
                                   },
                               new Room
                                   {
                                       ID = "102",
                                       Name = "102",
                                       BedNum = 1,
                                       Telphone = "12345",
                                       RoomType = roomType.FirstOrDefault(x => x.ID == 3),
                                       RoomState = roomStates.FirstOrDefault(x => x.ID == 2),
                                       Floor = floors.FirstOrDefault(x => x.ID == 1)
                                   },
                               new Room
                                   {
                                       ID = "103",
                                       Name = "103",
                                       BedNum = 2,
                                       Telphone = "12345",
                                       RoomType = roomType.FirstOrDefault(x => x.ID == 2),
                                       RoomState = roomStates.FirstOrDefault(x => x.ID == 3),
                                       Floor = floors.FirstOrDefault(x => x.ID == 1)
                                   },
                               new Room
                                   {
                                       ID = "104",
                                       Name = "104",
                                       BedNum = 1,
                                       Telphone = "12345",
                                       RoomType = roomType.FirstOrDefault(x => x.ID == 2),
                                       RoomState = roomStates.FirstOrDefault(x => x.ID == 1),
                                       Floor = floors.FirstOrDefault(x => x.ID == 1)
                                   },
                               new Room
                                   {
                                       ID = "105",
                                       Name = "105",
                                       BedNum = 1,
                                       Telphone = "12345",
                                       RoomType = roomType.FirstOrDefault(x => x.ID == 1),
                                       RoomState = roomStates.FirstOrDefault(x => x.ID == 3),
                                       Floor = floors.FirstOrDefault(x => x.ID == 1)
                                   },

                               new Room
                                   {
                                       ID = "201",
                                       Name = "201",
                                       BedNum = 2,
                                       Telphone = "12345",
                                       RoomType = roomType.FirstOrDefault(x => x.ID == 4),
                                       RoomState = roomStates.FirstOrDefault(x => x.ID == 2),
                                       Floor = floors.FirstOrDefault(x => x.ID == 2)
                                   },
                               new Room
                                   {
                                       ID = "202",
                                       Name = "202",
                                       BedNum = 1,
                                       Telphone = "12345",
                                       RoomType = roomType.FirstOrDefault(x => x.ID == 3),
                                       RoomState = roomStates.FirstOrDefault(x => x.ID == 4),
                                       Floor = floors.FirstOrDefault(x => x.ID == 2)
                                   },
                               new Room
                                   {
                                       ID = "203",
                                       Name = "203",
                                       BedNum = 1,
                                       Telphone = "12345",
                                       RoomType = roomType.FirstOrDefault(x => x.ID == 3),
                                       RoomState = roomStates.FirstOrDefault(x => x.ID == 1),
                                       Floor = floors.FirstOrDefault(x => x.ID == 2)
                                   },
                               new Room
                                   {
                                       ID = "204",
                                       Name = "204",
                                       BedNum = 2,
                                       Telphone = "12345",
                                       RoomType = roomType.FirstOrDefault(x => x.ID == 2),
                                       RoomState = roomStates.FirstOrDefault(x => x.ID == 1),
                                       Floor = floors.FirstOrDefault(x => x.ID == 2)
                                   },
                               new Room
                                   {
                                       ID = "205",
                                       Name = "205",
                                       BedNum = 1,
                                       Telphone = "12345",
                                       RoomType = roomType.FirstOrDefault(x => x.ID == 6),
                                       RoomState = roomStates.FirstOrDefault(x => x.ID == 1),
                                       Floor = floors.FirstOrDefault(x => x.ID == 2)
                                   },

                               new Room
                                   {
                                       ID = "301",
                                       Name = "301",
                                       BedNum = 1,
                                       Telphone = "12345",
                                       RoomType = roomType.FirstOrDefault(x => x.ID == 1),
                                       RoomState = roomStates.FirstOrDefault(x => x.ID == 1),
                                       Floor = floors.FirstOrDefault(x => x.ID == 3)
                                   },
                               new Room
                                   {
                                       ID = "302",
                                       Name = "302",
                                       BedNum = 2,
                                       Telphone = "12345",
                                       RoomType = roomType.FirstOrDefault(x => x.ID == 1),
                                       RoomState = roomStates.FirstOrDefault(x => x.ID == 1),
                                       Floor = floors.FirstOrDefault(x => x.ID == 3)
                                   },
                               new Room
                                   {
                                       ID = "303",
                                       Name = "303",
                                       BedNum = 1,
                                       Telphone = "12345",
                                       RoomType = roomType.FirstOrDefault(x => x.ID == 6),
                                       RoomState = roomStates.FirstOrDefault(x => x.ID == 2),
                                       Floor = floors.FirstOrDefault(x => x.ID == 3)
                                   },
                               new Room
                                   {
                                       ID = "304",
                                       Name = "304",
                                       BedNum = 2,
                                       Telphone = "12345",
                                       RoomType = roomType.FirstOrDefault(x => x.ID == 1),
                                       RoomState = roomStates.FirstOrDefault(x => x.ID == 1),
                                       Floor = floors.FirstOrDefault(x => x.ID == 3)
                                   },
                               new Room
                                   {
                                       ID = "305",
                                       Name = "305",
                                       BedNum = 1,
                                       Telphone = "12345",
                                       RoomType = roomType.FirstOrDefault(x => x.ID == 1),
                                       RoomState = roomStates.FirstOrDefault(x => x.ID == 3),
                                       Floor = floors.FirstOrDefault(x => x.ID == 3)
                                   },

                               new Room
                                   {
                                       ID = "401",
                                       Name = "401",
                                       BedNum = 1,
                                       Telphone = "12345",
                                       RoomType = roomType.FirstOrDefault(x => x.ID == 6),
                                       RoomState = roomStates.FirstOrDefault(x => x.ID == 1),
                                       Floor = floors.FirstOrDefault(x => x.ID == 4)
                                   },
                               new Room
                                   {
                                       ID = "402",
                                       Name = "402",
                                       BedNum = 1,
                                       Telphone = "12345",
                                       RoomType = roomType.FirstOrDefault(x => x.ID == 3),
                                       RoomState = roomStates.FirstOrDefault(x => x.ID == 4),
                                       Floor = floors.FirstOrDefault(x => x.ID == 4)
                                   },
                               new Room
                                   {
                                       ID = "403",
                                       Name = "403",
                                       BedNum = 2,
                                       Telphone = "12345",
                                       RoomType = roomType.FirstOrDefault(x => x.ID == 2),
                                       RoomState = roomStates.FirstOrDefault(x => x.ID == 1),
                                       Floor = floors.FirstOrDefault(x => x.ID == 4)
                                   },
                               new Room
                                   {
                                       ID = "404",
                                       Name = "404",
                                       BedNum = 1,
                                       Telphone = "12345",
                                       RoomType = roomType.FirstOrDefault(x => x.ID == 1),
                                       RoomState = roomStates.FirstOrDefault(x => x.ID == 1),
                                       Floor = floors.FirstOrDefault(x => x.ID == 4)
                                   },
                               new Room
                                   {
                                       ID = "405",
                                       Name = "405",
                                       BedNum = 1,
                                       Telphone = "12345",
                                       RoomType = roomType.FirstOrDefault(x => x.ID == 6),
                                       RoomState = roomStates.FirstOrDefault(x => x.ID == 4),
                                       Floor = floors.FirstOrDefault(x => x.ID == 4)
                                   },

                               new Room
                                   {
                                       ID = "501",
                                       Name = "501",
                                       BedNum = 1,
                                       Telphone = "12345",
                                       RoomType = roomType.FirstOrDefault(x => x.ID == 1),
                                       RoomState = roomStates.FirstOrDefault(x => x.ID == 1),
                                       Floor = floors.FirstOrDefault(x => x.ID == 5)
                                   },
                               new Room
                                   {
                                       ID = "502",
                                       Name = "502",
                                       BedNum = 1,
                                       Telphone = "12345",
                                       RoomType = roomType.FirstOrDefault(x => x.ID == 3),
                                       RoomState = roomStates.FirstOrDefault(x => x.ID == 1),
                                       Floor = floors.FirstOrDefault(x => x.ID == 5)
                                   },
                               new Room
                                   {
                                       ID = "503",
                                       Name = "503",
                                       BedNum = 2,
                                       Telphone = "12345",
                                       RoomType = roomType.FirstOrDefault(x => x.ID == 2),
                                       RoomState = roomStates.FirstOrDefault(x => x.ID == 2),
                                       Floor = floors.FirstOrDefault(x => x.ID == 5)
                                   },
                               new Room
                                   {
                                       ID = "504",
                                       Name = "504",
                                       BedNum = 1,
                                       Telphone = "12345",
                                       RoomType = roomType.FirstOrDefault(x => x.ID == 1),
                                       RoomState = roomStates.FirstOrDefault(x => x.ID == 1),
                                       Floor = floors.FirstOrDefault(x => x.ID == 5)
                                   },
                               new Room
                                   {
                                       ID = "505",
                                       Name = "505",
                                       BedNum = 1,
                                       Telphone = "12345",
                                       RoomType = roomType.FirstOrDefault(x => x.ID == 1),
                                       RoomState = roomStates.FirstOrDefault(x => x.ID == 1),
                                       Floor = floors.FirstOrDefault(x => x.ID == 5)
                                   },

                               new Room
                                   {
                                       ID = "601",
                                       Name = "601",
                                       BedNum = 2,
                                       Telphone = "12345",
                                       RoomType = roomType.FirstOrDefault(x => x.ID == 2),
                                       RoomState = roomStates.FirstOrDefault(x => x.ID == 1),
                                       Floor = floors.FirstOrDefault(x => x.ID == 6)
                                   },
                               new Room
                                   {
                                       ID = "602",
                                       Name = "602",
                                       BedNum = 1,
                                       Telphone = "12345",
                                       RoomType = roomType.FirstOrDefault(x => x.ID == 1),
                                       RoomState = roomStates.FirstOrDefault(x => x.ID == 1),
                                       Floor = floors.FirstOrDefault(x => x.ID == 6)
                                   },
                               new Room
                                   {
                                       ID = "603",
                                       Name = "603",
                                       BedNum = 2,
                                       Telphone = "12345",
                                       RoomType = roomType.FirstOrDefault(x => x.ID == 4),
                                       RoomState = roomStates.FirstOrDefault(x => x.ID == 3),
                                       Floor = floors.FirstOrDefault(x => x.ID == 6)
                                   },
                               new Room
                                   {
                                       ID = "604",
                                       Name = "604",
                                       BedNum = 1,
                                       Telphone = "12345",
                                       RoomType = roomType.FirstOrDefault(x => x.ID == 1),
                                       RoomState = roomStates.FirstOrDefault(x => x.ID == 4),
                                       Floor = floors.FirstOrDefault(x => x.ID == 6)
                                   },
                               new Room
                                   {
                                       ID = "605",
                                       Name = "605",
                                       BedNum = 1,
                                       Telphone = "12345",
                                       RoomType = roomType.FirstOrDefault(x => x.ID == 6),
                                       RoomState = roomStates.FirstOrDefault(x => x.ID == 1),
                                       Floor = floors.FirstOrDefault(x => x.ID == 6)
                                   },
                                    new Room
                                   {
                                       ID = "701",
                                       Name = "701",
                                       BedNum = 2,
                                       Telphone = "12345",
                                       RoomType = roomType.FirstOrDefault(x => x.ID == 2),
                                       RoomState = roomStates.FirstOrDefault(x => x.ID == 1),
                                       Floor = floors.FirstOrDefault(x => x.ID ==7)
                                   },
                               new Room
                                   {
                                       ID = "702",
                                       Name = "702",
                                       BedNum = 1,
                                       Telphone = "12345",
                                       RoomType = roomType.FirstOrDefault(x => x.ID == 1),
                                       RoomState = roomStates.FirstOrDefault(x => x.ID == 1),
                                       Floor = floors.FirstOrDefault(x => x.ID == 7)
                                   },
                               new Room
                                   {
                                       ID = "703",
                                       Name = "703",
                                       BedNum = 2,
                                       Telphone = "12345",
                                       RoomType = roomType.FirstOrDefault(x => x.ID == 4),
                                       RoomState = roomStates.FirstOrDefault(x => x.ID == 3),
                                       Floor = floors.FirstOrDefault(x => x.ID ==7)
                                   },
                               new Room
                                   {
                                       ID = "704",
                                       Name = "704",
                                       BedNum = 1,
                                       Telphone = "12345",
                                       RoomType = roomType.FirstOrDefault(x => x.ID == 1),
                                       RoomState = roomStates.FirstOrDefault(x => x.ID == 4),
                                       Floor = floors.FirstOrDefault(x => x.ID == 7)
                                   },
                               new Room
                                   {
                                       ID = "705",
                                       Name = "705",
                                       BedNum = 1,
                                       Telphone = "12345",
                                       RoomType = roomType.FirstOrDefault(x => x.ID == 6),
                                       RoomState = roomStates.FirstOrDefault(x => x.ID == 1),
                                       Floor = floors.FirstOrDefault(x => x.ID == 7)
                                   },
                                    new Room
                                   {
                                       ID = "801",
                                       Name = "801",
                                       BedNum = 2,
                                       Telphone = "12345",
                                       RoomType = roomType.FirstOrDefault(x => x.ID == 2),
                                       RoomState = roomStates.FirstOrDefault(x => x.ID == 1),
                                       Floor = floors.FirstOrDefault(x => x.ID ==8)
                                   },
                               new Room
                                   {
                                       ID = "802",
                                       Name = "802",
                                       BedNum = 1,
                                       Telphone = "12345",
                                       RoomType = roomType.FirstOrDefault(x => x.ID == 1),
                                       RoomState = roomStates.FirstOrDefault(x => x.ID == 1),
                                       Floor = floors.FirstOrDefault(x => x.ID == 8)
                                   },
                               new Room
                                   {
                                       ID = "803",
                                       Name = "803",
                                       BedNum = 2,
                                       Telphone = "12345",
                                       RoomType = roomType.FirstOrDefault(x => x.ID == 4),
                                       RoomState = roomStates.FirstOrDefault(x => x.ID == 3),
                                       Floor = floors.FirstOrDefault(x => x.ID ==8)
                                   },
                               new Room
                                   {
                                       ID = "804",
                                       Name = "804",
                                       BedNum = 1,
                                       Telphone = "12345",
                                       RoomType = roomType.FirstOrDefault(x => x.ID == 1),
                                       RoomState = roomStates.FirstOrDefault(x => x.ID == 4),
                                       Floor = floors.FirstOrDefault(x => x.ID == 8)
                                   },
                               new Room
                                   {
                                       ID = "805",
                                       Name = "805",
                                       BedNum = 1,
                                       Telphone = "12345",
                                       RoomType = roomType.FirstOrDefault(x => x.ID == 6),
                                       RoomState = roomStates.FirstOrDefault(x => x.ID == 5),
                                       Floor = floors.FirstOrDefault(x => x.ID == 8)
                                   },
                                    new Room
                                   {
                                       ID = "806",
                                       Name = "806",
                                       BedNum = 2,
                                       Telphone = "12345",
                                       RoomType = roomType.FirstOrDefault(x => x.ID == 2),
                                       RoomState = roomStates.FirstOrDefault(x => x.ID == 1),
                                       Floor = floors.FirstOrDefault(x => x.ID ==8)
                                   },
                               new Room
                                   {
                                       ID = "807",
                                       Name = "807",
                                       BedNum = 1,
                                       Telphone = "12345",
                                       RoomType = roomType.FirstOrDefault(x => x.ID == 1),
                                       RoomState = roomStates.FirstOrDefault(x => x.ID == 5),
                                       Floor = floors.FirstOrDefault(x => x.ID == 8)
                                   }
                               

                           };
            //住房+预订
            var hotelinginfomation = new List<HotelingInfomation>
                                         {
                                            

                                         };
            //住房历史
            var hotelingHistory = new List<HotelingHistory>
                                      {
                                          

                                      };
            //客户信息
            var client = new List<Client>
                             {
                                 //new Client
                                 //    {
                                 //        ID = "1",
                                 //        Name = "小王",
                                 //        ClientType = clientTypes.FirstOrDefault(x => x.ID == 1),
                                 //        Sex = "男",
                                 //        CertificateType = certificateTypes.FirstOrDefault(x => x.ID == 1),
                                 //        CertID = "45",
                                 //        Address = "江苏",
                                 //        PresentAddress = "ef",
                                 //        Telphone = "1545655",
                                 //        Vocation = "dsfjk",
                                 //        CompanyName = "宁时代",
                                 //        Birthday = DateTime.Now,
                                 //        IsFreeze = true,
                                 //        Memo = "dfs",
                                 //        HotelingInfomation = hotelinginfomation.FirstOrDefault(x => x.ID == "1")
                                 //    },
                                 //new Client
                                 //    {
                                 //        ID = "2",
                                 //        Name = "小王",
                                 //        ClientType = clientTypes.FirstOrDefault(x => x.ID == 1),
                                 //        Sex = "男",
                                 //        CertificateType = certificateTypes.FirstOrDefault(x => x.ID == 1),
                                 //        CertID = "45",
                                 //        Address = "江苏",
                                 //        PresentAddress = "ef",
                                 //        Telphone = "1545655",
                                 //        Vocation = "dsfjk",
                                 //        CompanyName = "宁时代",
                                 //        Birthday = DateTime.Now,
                                 //        IsFreeze = true,
                                 //        Memo = "dfs",
                                 //        HotelingInfomation = hotelinginfomation.FirstOrDefault(x => x.ID == "1")
                                 //    },
                                 //new Client
                                 //    {
                                 //        ID = "3",
                                 //        Name = "小王",
                                 //        ClientType = clientTypes.FirstOrDefault(x => x.ID == 1),
                                 //        Sex = "男",
                                 //        CertificateType = certificateTypes.FirstOrDefault(x => x.ID == 1),
                                 //        CertID = "45",
                                 //        Address = "江苏",
                                 //        PresentAddress = "ef",
                                 //        Telphone = "1545655",
                                 //        Vocation = "dsfjk",
                                 //        CompanyName = "宁时代",
                                 //        Birthday = DateTime.Now,
                                 //        IsFreeze = true,
                                 //        Memo = "dfs",
                                 //        HotelingInfomation = hotelinginfomation.FirstOrDefault(x => x.ID == "1")
                                 //    },
                                 //new Client
                                 //    {
                                 //        ID = "4",
                                 //        Name = "小王",
                                 //        ClientType = clientTypes.FirstOrDefault(x => x.ID == 1),
                                 //        Sex = "男",
                                 //        CertificateType = certificateTypes.FirstOrDefault(x => x.ID == 1),
                                 //        CertID = "45",
                                 //        Address = "江苏",
                                 //        PresentAddress = "ef",
                                 //        Telphone = "1545655",
                                 //        Vocation = "dsfjk",
                                 //        CompanyName = "宁时代",
                                 //        Birthday = DateTime.Now,
                                 //        IsFreeze = true,
                                 //        Memo = "dfs",
                                 //        HotelingInfomation = hotelinginfomation.FirstOrDefault(x => x.ID == "1")
                                 //    },
                                 //new Client
                                 //    {
                                 //        ID = "5",
                                 //        Name = "小王",
                                 //        ClientType = clientTypes.FirstOrDefault(x => x.ID == 1),
                                 //        Sex = "男",
                                 //        CertificateType = certificateTypes.FirstOrDefault(x => x.ID == 1),
                                 //        CertID = "45",
                                 //        Address = "江苏",
                                 //        PresentAddress = "ef",
                                 //        Telphone = "1545655",
                                 //        Vocation = "dsfjk",
                                 //        CompanyName = "宁时代",
                                 //        Birthday = DateTime.Now,
                                 //        IsFreeze = true,
                                 //        Memo = "dfs",
                                 //        HotelingInfomation = hotelinginfomation.FirstOrDefault(x => x.ID == "1")
                                 //    },
                                 //new Client
                                 //    {
                                 //        ID = "6",
                                 //        Name = "小王",
                                 //        ClientType = clientTypes.FirstOrDefault(x => x.ID == 1),
                                 //        Sex = "男",
                                 //        CertificateType = certificateTypes.FirstOrDefault(x => x.ID == 1),
                                 //        CertID = "45",
                                 //        Address = "江苏",
                                 //        PresentAddress = "ef",
                                 //        Telphone = "1545655",
                                 //        Vocation = "dsfjk",
                                 //        CompanyName = "宁时代",
                                 //        Birthday = DateTime.Now,
                                 //        IsFreeze = true,
                                 //        Memo = "dfs",
                                 //        HotelingInfomation = hotelinginfomation.FirstOrDefault(x => x.ID == "1")
                                 //    },
                                 //new Client
                                 //    {
                                 //        ID = "7",
                                 //        Name = "小王",
                                 //        ClientType = clientTypes.FirstOrDefault(x => x.ID == 1),
                                 //        Sex = "男",
                                 //        CertificateType = certificateTypes.FirstOrDefault(x => x.ID == 1),
                                 //        CertID = "45",
                                 //        Address = "江苏",
                                 //        PresentAddress = "ef",
                                 //        Telphone = "1545655",
                                 //        Vocation = "dsfjk",
                                 //        CompanyName = "宁时代",
                                 //        Birthday = DateTime.Now,
                                 //        IsFreeze = true,
                                 //        Memo = "dfs",
                                 //        HotelingInfomation = hotelinginfomation.FirstOrDefault(x => x.ID == "1")
                                 //    },
                                 //new Client
                                 //    {
                                 //        ID = "8",
                                 //        Name = "小王",
                                 //        ClientType = clientTypes.FirstOrDefault(x => x.ID == 1),
                                 //        Sex = "男",
                                 //        CertificateType = certificateTypes.FirstOrDefault(x => x.ID == 1),
                                 //        CertID = "45",
                                 //        Address = "江苏",
                                 //        PresentAddress = "ef",
                                 //        Telphone = "1545655",
                                 //        Vocation = "dsfjk",
                                 //        CompanyName = "宁时代",
                                 //        Birthday = DateTime.Now,
                                 //        IsFreeze = true,
                                 //        Memo = "dfs",
                                 //        HotelingInfomation = hotelinginfomation.FirstOrDefault(x => x.ID == "1")
                                 //    },
                                 //new Client
                                 //    {
                                 //        ID = "9",
                                 //        Name = "小王",
                                 //        ClientType = clientTypes.FirstOrDefault(x => x.ID == 1),
                                 //        Sex = "男",
                                 //        CertificateType = certificateTypes.FirstOrDefault(x => x.ID == 1),
                                 //        CertID = "45",
                                 //        Address = "江苏",
                                 //        PresentAddress = "ef",
                                 //        Telphone = "1545655",
                                 //        Vocation = "dsfjk",
                                 //        CompanyName = "宁时代",
                                 //        Birthday = DateTime.Now,
                                 //        IsFreeze = true,
                                 //        Memo = "dfs",
                                 //        HotelingInfomation = hotelinginfomation.FirstOrDefault(x => x.ID == "1")
                                 //    },
                                 //new Client
                                 //    {
                                 //        ID = "10",
                                 //        Name = "小王",
                                 //        ClientType = clientTypes.FirstOrDefault(x => x.ID == 1),
                                 //        Sex = "男",
                                 //        CertificateType = certificateTypes.FirstOrDefault(x => x.ID == 1),
                                 //        CertID = "45",
                                 //        Address = "江苏",
                                 //        PresentAddress = "ef",
                                 //        Telphone = "1545655",
                                 //        Vocation = "dsfjk",
                                 //        CompanyName = "宁时代",
                                 //        Birthday = DateTime.Now,
                                 //        IsFreeze = true,
                                 //        Memo = "dfs",
                                 //        HotelingInfomation = hotelinginfomation.FirstOrDefault(x => x.ID == "1")
                                 //    }

                             };
            //货品
            var products = new List<Product>
                               {
                                   new Product
                                       {
                                           ID = 1,
                                           Name = "康师傅",
                                           Count = 50,
                                           PriceOut = 11,
                                           Remark = "康师傅很好",
                                           ProductCategory = productCategories.FirstOrDefault(x => x.ID == 1)
                                       },
                                   new Product
                                       {
                                           ID = 2,
                                           Name = "农夫山泉",
                                           Count = 50,
                                           PriceOut = 10,
                                           Remark = "农夫山泉很好",
                                           ProductCategory = productCategories.FirstOrDefault(x => x.ID == 1)
                                       },
                                   new Product
                                       {
                                           ID = 3,
                                           Name = "百味泉",
                                           Count = 50,
                                           PriceOut = 13,
                                           Remark = "百味泉很好",
                                           ProductCategory = productCategories.FirstOrDefault(x => x.ID == 1)
                                       },
                                   new Product
                                       {
                                           ID = 4,
                                           Name = "幸福山泉",
                                           Count = 50,
                                           PriceOut = 10,
                                           Remark = "幸福山泉很好",
                                           ProductCategory = productCategories.FirstOrDefault(x => x.ID == 1)
                                       },
                                   new Product
                                       {
                                           ID = 5,
                                           Name = "烤面包",
                                           Count = 50,
                                           PriceOut = 16,
                                           Remark = "烤面包很好",
                                           ProductCategory = productCategories.FirstOrDefault(x => x.ID == 2)
                                       },
                                   new Product
                                       {
                                           ID = 6,
                                           Name = "大面包",
                                           Count = 50,
                                           PriceOut = 15,
                                           Remark = "大面包很好",
                                           ProductCategory = productCategories.FirstOrDefault(x => x.ID == 2)
                                       },
                                   new Product
                                       {
                                           ID = 7,
                                           Name = "康师傅面",
                                           Count = 50,
                                           PriceOut = 13,
                                           Remark = "康师傅面很好",
                                           ProductCategory = productCategories.FirstOrDefault(x => x.ID == 3)
                                       },
                                   new Product
                                       {
                                           ID = 8,
                                           Name = "红豆内衣",
                                           Count = 50,
                                           PriceOut = 13,
                                           Remark = "红豆内衣很好",
                                           ProductCategory = productCategories.FirstOrDefault(x => x.ID == 4)
                                       },
                                   new Product
                                       {
                                           ID = 9,
                                           Name = "红豆内裤",
                                           Count = 50,
                                           PriceOut = 10,
                                           Remark = "红豆内裤很好",
                                           ProductCategory = productCategories.FirstOrDefault(x => x.ID == 5)
                                       },
                                   new Product
                                       {
                                           ID = 10,
                                           Name = "七匹狼内裤",
                                           Count = 50,
                                           PriceOut = 10,
                                           Remark = "七匹狼内裤很好",
                                           ProductCategory = productCategories.FirstOrDefault(x => x.ID == 5)
                                       },
                                   new Product
                                       {
                                           ID = 11,
                                           Name = "红豆袜子",
                                           Count = 50,
                                           PriceOut = 10,
                                           Remark = "红豆袜子很好",
                                           ProductCategory = productCategories.FirstOrDefault(x => x.ID == 6)
                                       },
                                   new Product
                                       {
                                           ID = 12,
                                           Name = "七匹狼袜子",
                                           Count = 50,
                                           PriceOut = 12,
                                           Remark = "七匹狼袜子很好",
                                           ProductCategory = productCategories.FirstOrDefault(x => x.ID == 6)
                                       },
                                   new Product
                                       {
                                           ID = 13,
                                           Name = "清扬",
                                           Count = 50,
                                           PriceOut = 12,
                                           Remark = "清扬很好",
                                           ProductCategory = productCategories.FirstOrDefault(x => x.ID == 7)
                                       },
                                   new Product
                                       {
                                           ID = 14,
                                           Name = "花香",
                                           Count = 50,
                                           PriceOut = 12,
                                           Remark = "花香很好",
                                           ProductCategory = productCategories.FirstOrDefault(x => x.ID == 7)
                                       },
                                   new Product
                                       {
                                           ID = 15,
                                           Name = "飘柔",
                                           Count = 50,
                                           PriceOut = 12,
                                           Remark = "飘柔很好",
                                           ProductCategory = productCategories.FirstOrDefault(x => x.ID == 7)
                                       },
                                   new Product
                                       {
                                           ID = 16,
                                           Name = "海飞丝",
                                           Count = 50,
                                           PriceOut = 12,
                                           Remark = "海飞丝很好",
                                           ProductCategory = productCategories.FirstOrDefault(x => x.ID == 7)
                                       },
                                   new Product
                                       {
                                           ID = 17,
                                           Name = "霸王",
                                           Count = 50,
                                           PriceOut = 12,
                                           Remark = "霸王很好",
                                           ProductCategory = productCategories.FirstOrDefault(x => x.ID == 7)
                                       },
                                   new Product
                                       {
                                           ID = 18,
                                           Name = "隆力奇",
                                           Count = 50,
                                           PriceOut = 12,
                                           Remark = "隆力奇很好",
                                           ProductCategory = productCategories.FirstOrDefault(x => x.ID == 7)
                                       },


                                   //
                               };
            //用户消费信息
            var clientConsumptions = new List<ClientConsumption>
                                         {
                                             

                                         };
           
         

        

         

           
            productCategories.ForEach(u => context.ProductCategories.Add(u));
            
            certificateTypes.ForEach(u => context.CertificateTypes.Add(u));
            clientTypes.ForEach(u => context.ClientTypes.Add(u));
            roomType.ForEach(u => context.RoomTypes.Add(u));
            floors.ForEach(u => context.Floors.Add(u));
            roomStates.ForEach(u => context.RoomStates.Add(u));
         
            products.ForEach(u => context.Products.Add(u));
            client.ForEach(u => context.Clients.Add(u));
           
            room.ForEach(u => context.Rooms.Add(u));
            hotelingHistory.ForEach(u => context.HotelingHistories.Add(u));
            hotelinginfomation.ForEach(u => context.HotelingInfomations.Add(u));
            clientConsumptions.ForEach(u => context.ClientConsumptions.Add(u));

            context.SaveChanges();
            base.Seed(context);
        }
    }
}
